Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)
Previous Next

try backend RDMS + Notes....

Notes was made more for collaboration than a monster RDMS.

Two million is just a lot, and I would bet any RDMS system would run circles around Notes if all you are doing is query's or @dblookup-like calls.

(I have create MS Access databases that takes user's data with simple joins and where clauses to create reports in 10 seconds where the same data in MS Excel took over 2 hours.)

I would try exporting the data to a backend RDMS like DB2, Oracle, or SQL Server. Index it accordingly and properly for performance. If you can keep it on the same box, it will tax your CPU but save you networking calls. Then, use LEI if performance is important to connect to the information in Lotus Notes. (note, LEI can be much faster than ODBC if the LEI is using the native drivers.)

-Kyle Huang


Feedback response number WEBB8MATNM created by ~John Reniskiikle on 10/03/2011

Lotus Approach to Notes - 2 million... (~Nita Quetboosi... 30.Sep.11)
. . try backend RDMS + Notes.... (~John Reniskiik... 3.Oct.11)
. . . . Thanks Kyle (~Nita Quetboosi... 4.Oct.11)
. . . . . . also, remember the "cache" (~John Reniskiik... 4.Oct.11)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS